#ifndef CONNECTION_H
#define CONNECTION_H

#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>

//! [0]
static bool createConnection()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    //db.setDatabaseName(":memory:");
    db.setDatabaseName("thoughts.db");
    if (!db.open()) {

            qDebug() << "Error - database did not open";
//        QMessageBox::critical(0, qApp->tr("Cannot open database"),
//            qApp->tr("Unable to establish a database connection.\n"
//                     "This example needs SQLite support. Please read "
//                     "the Qt SQL driver documentation for information how "
//                     "to build it.\n\n"
//                     "Click Cancel to exit."), QMessageBox::Cancel);
        return false;


    }

    qDebug() << "We've opened the database";

    QSqlQuery query;
    query.exec("create table person (id int primary key, "
               "firstname varchar(20), lastname varchar(20))");

    query.exec("insert into person values(131, 'Calvin', 'Klien')");
    query.exec("insert into person values(132, 'Hanes', 'UltraSoft')");
//    query.exec("insert into person values(103, 'Lars', 'Gordon')");
//    query.exec("insert into person values(104, 'Roberto', 'Robitaille')");
//    query.exec("insert into person values(105, 'Maria', 'Papadopoulos')");
//    query.exec("insert into person values(106, 'Todd', 'Morgan')");
//    query.exec("insert into person values(107, 'Jack', 'Sparrow')");
//    query.exec("insert into person values(108, 'Kirt', 'Stark')");
//    query.exec("insert into person values(109, 'Jana', 'Stark')");
//    query.exec("insert into person values(110, 'Jessica', 'Alba')");
//    query.exec("insert into person values(122, 'Tabbatha', 'Jones')");


//    query.exec("create table persons (id int primary key, "
//               "firstname varchar(20), lastname varchar(20))");
//    query.exec("insert into persons values(101, 'Danny', 'Young')");
//    query.exec("insert into persons values(113, 'Christine', 'Davis')");
//    query.exec("insert into persons values(103, 'Lars', 'Gordon')");
//    query.exec("insert into persons values(104, 'Roberto', 'Robitaille')");
//    query.exec("insert into persons values(105, 'Maria', 'Papadopoulos')");
//    query.exec("insert into persons values(106, 'Todd', 'Morgan')");
//    query.exec("insert into persons values(107, 'Jack', 'Sparrow')");
//    query.exec("insert into persons values(108, 'Kirt', 'Stark')");
//    query.exec("insert into persons values(109, 'Jack', 'Stark')");
    query.exec("insert into persons values(120, 'Bill', 'Bird')");






//    query.exec("create table items (id int primary key,"
//                                             "imagefile int,"
//                                             "itemtype varchar(20),"
//                                             "description varchar(100))");
//    query.exec("insert into items "
//               "values(0, 0, 'Qt',"
//               "'Qt is a full development framework with tools designed to "
//               "streamline the creation of stunning applications and  "
//               "amazing user interfaces for desktop, embedded and mobile "
//               "platforms.')");
//    query.exec("insert into items "
//               "values(1, 1, 'Qt Quick',"
//               "'Qt Quick is a collection of techniques designed to help "
//               "developers create intuitive, modern-looking, and fluid "
//               "user interfaces using a CSS & JavaScript like language.')");
//    query.exec("insert into items "
//               "values(2, 2, 'Qt Creator',"
//               "'Qt Creator is a powerful cross-platform integrated "
//               "development environment (IDE), including UI design tools "
//               "and on-device debugging.')");
//    query.exec("insert into items "
//               "values(3, 3, 'Qt Project',"
//               "'The Qt Project governs the open source development of Qt, "
//               "allowing anyone wanting to contribute to join the effort "
//               "through a meritocratic structure of approvers and "
//               "maintainers.')");

//    query.exec("create table images (itemid int, file varchar(20))");
//    query.exec("insert into images values(0, 'images/qt-logo.png')");
//    query.exec("insert into images values(1, 'images/qt-quick.png')");
//    query.exec("insert into images values(2, 'images/qt-creator.png')");
//    query.exec("insert into images values(3, 'images/qt-project.png')");

    return true;
}
//! [0]


#endif // CONNECTION_H
